﻿

CREATE PROCEDURE [dbo].[ReportProcedure] AS
BEGIN
Select wa.DisplayName, s.UpgradeRedirectUri, w.ServerRelativeUrl,w.Size, l.Title, l.ItemCount from SiteCollection s, Web w, WebApplication wa, List l
where w.SiteCollectionID = s.SiteCollectionID
and s.WebApplicationID = wa.WebApplicationID
and l.WebID = w.WebID
	
	
	
END